﻿-- =============================================
-- Script Template
-- =============================================
USE [HRS]
GO
/****** Object:  Table [enterprise].[City]    Script Date: 04/20/2013 13:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [enterprise].[City](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CityCode] [int] NOT NULL,
	[Name] [nvarchar](256) NOT NULL,
 CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [enterprise].[City] ON
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (3, 1, N'Adana')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (4, 2, N'Adıyaman')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (5, 3, N'Afyonkarahisar')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (6, 4, N'Ağrı')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (7, 5, N'Amasya')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (8, 6, N'Ankara')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (9, 7, N'Antalya')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (10, 8, N'Artvin')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (11, 9, N'Aydın')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (12, 10, N'Balıkesir')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (13, 11, N'Bilecik')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (14, 12, N'Bingöl')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (15, 13, N'Bitlis')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (16, 14, N'Bolu')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (17, 15, N'Burdur')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (18, 16, N'Bursa')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (19, 17, N'Çanakkale')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (20, 18, N'Çankırı')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (21, 19, N'Çorum')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (22, 20, N'Denizli')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (23, 21, N'Diyarbakır')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (24, 22, N'Edirne')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (25, 23, N'Elazığ')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (26, 24, N'Erzincan')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (27, 25, N'Erzurum')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (28, 26, N'Eskişehir')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (29, 27, N'Gaziantep')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (30, 28, N'Giresun')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (31, 29, N'Gümüşhane')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (32, 30, N'Hakkari')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (33, 31, N'Hatay')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (34, 32, N'Isparta')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (35, 33, N'Mersin')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (36, 34, N'İstanbul')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (37, 35, N'İzmir')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (38, 36, N'Kars')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (39, 37, N'Kastamonu')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (40, 38, N'Kayseri')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (41, 39, N'Kırklareli')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (42, 40, N'Kırşehir')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (43, 41, N'Kocaeli')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (44, 42, N'Konya')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (45, 43, N'Kütahya')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (46, 44, N'Malatya')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (47, 45, N'Manisa')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (48, 46, N'Kahramanmaraş')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (49, 47, N'Mardin')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (50, 48, N'Muğla')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (51, 49, N'Muş')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (52, 50, N'Nevşehir')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (53, 51, N'Niğde')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (54, 52, N'Ordu')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (55, 53, N'Rize')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (56, 54, N'Sakarya')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (57, 55, N'Samsun')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (58, 56, N'Siirt')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (59, 57, N'Sinop')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (60, 58, N'Sivas')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (61, 59, N'Tekirdağ')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (62, 60, N'Tokat')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (63, 61, N'Trabzon')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (64, 62, N'Tunceli')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (65, 63, N'Şanlıurfa')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (66, 64, N'Uşak')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (67, 65, N'Van')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (68, 66, N'Yozgat')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (69, 67, N'Zonguldak')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (70, 68, N'Aksaray')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (71, 69, N'Bayburt')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (72, 70, N'Karaman')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (73, 71, N'Kırıkkale')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (74, 72, N'Batman')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (75, 73, N'Şırnak')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (76, 74, N'Bartın')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (77, 75, N'Ardahan')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (78, 76, N'Iğdır')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (79, 77, N'Yalova')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (80, 78, N'Karabük')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (81, 79, N'Kilis')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (82, 80, N'Osmaniye')
INSERT [enterprise].[City] ([Id], [CityCode], [Name]) VALUES (83, 81, N'Düzce')
SET IDENTITY_INSERT [enterprise].[City] OFF
/****** Object:  Table [enterprise].[Town]    Script Date: 04/20/2013 13:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [enterprise].[Town](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TownCode] [int] NOT NULL,
	[Name] [nvarchar](256) NOT NULL,
	[CityId] [int] NOT NULL,
 CONSTRAINT [PK_Town] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [enterprise].[Town] ON
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (1, 1757, N'Aladağ', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (2, 1219, N'Ceyhan', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (3, 2033, N'Çukurova', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (4, 1329, N'Feke', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (5, 1806, N'İmamoğlu', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (6, 1437, N'Karaisalı', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (7, 1443, N'Karataş', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (8, 1486, N'Kozan', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (9, 1580, N'Pozantı', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (10, 1588, N'Saimbeyli', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (11, 2032, N'Sarıçam', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (12, 1104, N'Seyhan', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (13, 1687, N'Tufanbeyli', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (14, 1734, N'Yumurtalık', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (15, 1748, N'Yüreğir', 3)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (16, 1105, N'Adıyaman Merkez', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (17, 1182, N'Besni', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (18, 1246, N'Çelikhan', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (19, 1347, N'Gerger', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (20, 1354, N'Gölbaşı / Adıyaman', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (21, 1425, N'Kahta', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (22, 1592, N'Samsat', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (23, 1985, N'Sincik', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (24, 1989, N'Tut', 4)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (25, 1108, N'Afyonkarahisar Merkez', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (26, 1771, N'Başmakçı', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (27, 1773, N'Bayat / Afyonkarahisar', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (28, 1200, N'Bolvadin', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (29, 1239, N'Çay', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (30, 1906, N'Çobanlar', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (31, 1267, N'Dazkırı', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (32, 1281, N'Dinar', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (33, 1306, N'Emirdağ', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (34, 1923, N'Evciler', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (35, 1944, N'Hocalar', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (36, 1404, N'İhsaniye', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (37, 1809, N'İscehisar', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (38, 1961, N'Kızılören', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (39, 1594, N'Sandıklı', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (40, 1626, N'Sinanpaşa', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (41, 1639, N'Sultandağı', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (42, 1664, N'Şuhut', 5)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (43, 1111, N'Ağrı Merkez', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (44, 1283, N'Diyadin', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (45, 1287, N'Doğubayazıt', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (46, 1301, N'Eleşkirt', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (47, 1379, N'Hamur', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (48, 1568, N'Patnos', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (49, 1667, N'Taşlıçay', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (50, 1691, N'Tutak', 6)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (51, 1134, N'Amasya Merkez', 7)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (52, 1363, N'Göynücek', 7)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (53, 1368, N'Gümüşhacıköy', 7)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (54, 1938, N'Hamamözü', 7)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (55, 1524, N'Merzifon', 7)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (56, 1641, N'Suluova', 7)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (57, 1668, N'Taşova', 7)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (58, 1872, N'Akyurt', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (59, 1130, N'Altındağ', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (60, 1157, N'Ayaş', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (61, 1167, N'Bala', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (62, 1187, N'Beypazarı', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (63, 1227, N'Çamlıdere', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (64, 1231, N'Çankaya', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (65, 1260, N'Çubuk', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (66, 1302, N'Elmadağ', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (67, 1922, N'Etimesgut', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (68, 1924, N'Evren', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (69, 1744, N'Gölbaşı / Ankara', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (70, 1365, N'Güdül', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (71, 1387, N'Haymana', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (72, 1427, N'Kalecik', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (73, 1815, N'Kazan', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (74, 1745, N'Keçiören', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (75, 1473, N'Kızılcahamam', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (76, 1746, N'Mamak', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (77, 1539, N'Nallıhan', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (78, 1578, N'Polatlı', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (79, 2034, N'Pursaklar', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (80, 1747, N'Sincan', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (81, 1658, N'Şereflikoçhisar', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (82, 1723, N'Yenimahalle', 8)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (83, 1121, N'Akseki', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (84, 2035, N'Aksu / Antalya', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (85, 1126, N'Alanya', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (86, 1811, N'Demre', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (87, 2036, N'Döşemealtı', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (88, 1303, N'Elmalı', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (89, 1333, N'Finike', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (90, 1337, N'Gazipaşa', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (91, 1370, N'Gündoğmuş', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (92, 1946, N'İbradı', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (93, 1451, N'Kaş', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (94, 1959, N'Kemer / Antalya', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (95, 2037, N'Kepez', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (96, 2038, N'Konyaaltı', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (97, 1483, N'Korkuteli', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (98, 1492, N'Kumluca', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (99, 1512, N'Manavgat', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (100, 2039, N'Muratpaşa', 9)
GO
print 'Processed 100 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (101, 1616, N'Serik', 9)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (102, 1145, N'Ardanuç', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (103, 1147, N'Arhavi', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (104, 1152, N'Artvin Merkez', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (105, 1202, N'Borçka', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (106, 1395, N'Hopa', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (107, 1828, N'Murgul', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (108, 1653, N'Şavşat', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (109, 1736, N'Yusufeli', 10)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (110, 1159, N'Aydın Merkez', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (111, 1206, N'Bozdoğan', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (112, 1781, N'Buharkent', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (113, 1256, N'Çine', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (114, 2000, N'Didim', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (115, 1348, N'Germencik', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (116, 1807, N'İncirliova', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (117, 1435, N'Karacasu', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (118, 1957, N'Karpuzlu', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (119, 1479, N'Koçarlı', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (120, 1968, N'Köşk', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (121, 1497, N'Kuşadası', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (122, 1498, N'Kuyucak', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (123, 1542, N'Nazilli', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (124, 1637, N'Söke', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (125, 1640, N'Sultanhisar', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (126, 1724, N'Yenipazar / Aydın', 11)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (127, 1161, N'Ayvalık', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (128, 1168, N'Balıkesir Merkez', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (129, 1169, N'Balya', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (130, 1171, N'Bandırma', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (131, 1191, N'Bigadiç', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (132, 1216, N'Burhaniye', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (133, 1291, N'Dursunbey', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (134, 1294, N'Edremit / Balıkesir', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (135, 1310, N'Erdek', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (136, 1928, N'Gömeç', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (137, 1360, N'Gönen / Balıkesir', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (138, 1384, N'Havran', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (139, 1418, N'İvrindi', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (140, 1462, N'Kepsut', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (141, 1514, N'Manyas', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (142, 1824, N'Marmara', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (143, 1608, N'Savaştepe', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (144, 1619, N'Sındırgı', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (145, 1644, N'Susurluk', 12)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (146, 1192, N'Bilecik Merkez', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (147, 1210, N'Bozüyük', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (148, 1359, N'Gölpazarı', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (149, 1948, N'İnhisar', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (150, 1559, N'Osmaneli', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (151, 1571, N'Pazaryeri', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (152, 1636, N'Söğüt', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (153, 1857, N'Yenipazar / Bilecik', 13)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (154, 1750, N'Adaklı', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (155, 1193, N'Bingöl Merkez', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (156, 1344, N'Genç', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (157, 1446, N'Karlıova', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (158, 1475, N'Kiğı', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (159, 1633, N'Solhan', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (160, 1855, N'Yayladere', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (161, 1996, N'Yedisu', 14)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (162, 1106, N'Adilcevaz', 15)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (163, 1112, N'Ahlat', 15)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (164, 1196, N'Bitlis Merkez', 15)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (165, 1798, N'Güroymak', 15)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (166, 1394, N'Hizan', 15)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (167, 1537, N'Mutki', 15)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (168, 1669, N'Tatvan', 15)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (169, 1199, N'Bolu Merkez', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (170, 1916, N'Dörtdivan', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (171, 1346, N'Gerede', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (172, 1364, N'Göynük', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (173, 1466, N'Kıbrıscık', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (174, 1522, N'Mengen', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (175, 1531, N'Mudurnu', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (176, 1610, N'Seben', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (177, 1997, N'Yeniçağa', 16)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (178, 1109, N'Ağlasun', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (179, 1874, N'Altınyayla / Burdur', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (180, 1211, N'Bucak', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (181, 1215, N'Burdur Merkez', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (182, 1899, N'Çavdır', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (183, 1903, N'Çeltikçi', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (184, 1357, N'Gölhisar', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (185, 1813, N'Karamanlı', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (186, 1816, N'Kemer / Burdur', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (187, 1672, N'Tefenni', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (188, 1728, N'Yeşilova', 17)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (189, 1783, N'Büyükorhan', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (190, 1343, N'Gemlik', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (191, 1935, N'Gürsu', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (192, 1799, N'Harmancık', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (193, 1411, N'İnegöl', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (194, 1420, N'İznik', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (195, 1434, N'Karacabey', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (196, 1457, N'Keles', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (197, 1960, N'Kestel', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (198, 1530, N'Mudanya', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (199, 1535, N'Mustafakemalpaşa', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (200, 1829, N'Nilüfer', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (201, 1553, N'Orhaneli', 18)
GO
print 'Processed 200 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (202, 1554, N'Orhangazi', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (203, 1832, N'Osmangazi', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (204, 1725, N'Yenişehir / Bursa', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (205, 1859, N'Yıldırım', 18)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (206, 1160, N'Ayvacık / Çanakkale', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (207, 1180, N'Bayramiç', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (208, 1190, N'Biga', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (209, 1205, N'Bozcaada', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (210, 1229, N'Çan', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (211, 1230, N'Çanakkale Merkez', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (212, 1293, N'Eceabat', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (213, 1326, N'Ezine', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (214, 1340, N'Gelibolu', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (215, 1408, N'Gökçeada', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (216, 1503, N'Lapseki', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (217, 1722, N'Yenice / Çanakkale', 19)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (218, 1765, N'Atkaracalar', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (219, 1885, N'Bayramören', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (220, 1232, N'Çankırı Merkez', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (221, 1248, N'Çerkeş', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (222, 1300, N'Eldivan', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (223, 1399, N'Ilgaz', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (224, 1817, N'Kızılırmak', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (225, 1963, N'Korgun', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (226, 1494, N'Kurşunlu', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (227, 1555, N'Orta', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (228, 1649, N'Şabanözü', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (229, 1718, N'Yapraklı', 20)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (230, 1124, N'Alaca', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (231, 1177, N'Bayat / Çorum', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (232, 1778, N'Boğazkale', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (233, 1259, N'Çorum Merkez', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (234, 1911, N'Dodurga', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (235, 1414, N'İskilip', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (236, 1445, N'Kargı', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (237, 1972, N'Laçin', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (238, 1520, N'Mecitözü', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (239, 1976, N'Oğuzlar', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (240, 1556, N'Ortaköy / Çorum', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (241, 1558, N'Osmancık', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (242, 1642, N'Sungurlu', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (243, 1850, N'Uğurludağ', 21)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (244, 1102, N'Acıpayam', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (245, 1871, N'Akköy', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (246, 1769, N'Babadağ', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (247, 1881, N'Baklan', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (248, 1774, N'Bekilli', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (249, 1888, N'Beyağaç', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (250, 1889, N'Bozkurt / Denizli', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (251, 1214, N'Buldan', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (252, 1224, N'Çal', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (253, 1226, N'Çameli', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (254, 1233, N'Çardak', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (255, 1257, N'Çivril', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (256, 1271, N'Denizli Merkez', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (257, 1371, N'Güney', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (258, 1803, N'Honaz', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (259, 1426, N'Kale / Denizli', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (260, 1597, N'Sarayköy', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (261, 1840, N'Serinhisar', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (262, 1670, N'Tavas', 22)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (263, 2040, N'Bağlar', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (264, 1195, N'Bismil', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (265, 1249, N'Çermik', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (266, 1253, N'Çınar', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (267, 1263, N'Çüngüş', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (268, 1278, N'Dicle', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (269, 1791, N'Eğil', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (270, 1315, N'Ergani', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (271, 1381, N'Hani', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (272, 1389, N'Hazro', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (273, 2041, N'Kayapınar', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (274, 1962, N'Kocaköy', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (275, 1490, N'Kulp', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (276, 1504, N'Lice', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (277, 1624, N'Silvan', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (278, 2042, N'Sur', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (279, 2043, N'Yenişehir / Diyarbakır', 23)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (280, 1295, N'Edirne Merkez', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (281, 1307, N'Enez', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (282, 1385, N'Havsa', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (283, 1412, N'İpsala', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (284, 1464, N'Keşan', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (285, 1502, N'Lalapaşa', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (286, 1523, N'Meriç', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (287, 1988, N'Süloğlu', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (288, 1705, N'Uzunköprü', 24)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (289, 1110, N'Ağın', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (290, 1873, N'Alacakaya', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (291, 1762, N'Arıcak', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (292, 1173, N'Baskil', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (293, 1298, N'Elazığ Merkez', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (294, 1438, N'Karakoçan', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (295, 1455, N'Keban', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (296, 1820, N'Kovancılar', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (297, 1506, N'Maden', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (298, 1566, N'Palu', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (299, 1631, N'Sivrice', 25)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (300, 1243, N'Çayırlı', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (301, 1318, N'Erzincan Merkez', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (302, 1406, N'İliç', 26)
GO
print 'Processed 300 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (303, 1459, N'Kemah', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (304, 1460, N'Kemaliye', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (305, 1977, N'Otlukbeli', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (306, 1583, N'Refahiye', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (307, 1675, N'Tercan', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (308, 1853, N'Üzümlü', 26)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (309, 1153, N'Aşkale', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (310, 1945, N'Aziziye', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (311, 1235, N'Çat', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (312, 1392, N'Hınıs', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (313, 1396, N'Horasan', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (314, 1416, N'İspir', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (315, 1812, N'Karaçoban', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (316, 1444, N'Karayazı', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (317, 1967, N'Köprüköy', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (318, 1540, N'Narman', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (319, 1550, N'Oltu', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (320, 1551, N'Olur', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (321, 2044, N'Palandöken', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (322, 1567, N'Pasinler', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (323, 1865, N'Pazaryolu', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (324, 1657, N'Şenkaya', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (325, 1674, N'Tekman', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (326, 1683, N'Tortum', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (327, 1851, N'Uzundere', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (328, 2045, N'Yakutiye', 27)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (329, 1759, N'Alpu', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (330, 1777, N'Beylikova', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (331, 1255, N'Çifteler', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (332, 1934, N'Günyüzü', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (333, 1939, N'Han', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (334, 1808, N'İnönü', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (335, 1508, N'Mahmudiye', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (336, 1973, N'Mihalgazi', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (337, 1527, N'Mihalıççık', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (338, 2046, N'Odunpazarı', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (339, 1599, N'Sarıcakaya', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (340, 1618, N'Seyitgazi', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (341, 1632, N'Sivrihisar', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (342, 2047, N'Tepebaşı', 28)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (343, 1139, N'Araban', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (344, 1415, N'İslahiye', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (345, 1956, N'Karkamış', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (346, 1546, N'Nizip', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (347, 1974, N'Nurdağı', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (348, 1549, N'Oğuzeli', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (349, 1841, N'Şahinbey', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (350, 1844, N'Şehitkamil', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (351, 1720, N'Yavuzeli', 29)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (352, 1133, N'Alucra', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (353, 1212, N'Bulancak', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (354, 1893, N'Çamoluk', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (355, 1894, N'Çanakçı', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (356, 1272, N'Dereli', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (357, 1912, N'Doğankent', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (358, 1320, N'Espiye', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (359, 1324, N'Eynesil', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (360, 1352, N'Giresun Merkez', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (361, 1361, N'Görele', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (362, 1930, N'Güce', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (363, 1465, N'Keşap', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (364, 1837, N'Piraziz', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (365, 1654, N'Şebinkarahisar', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (366, 1678, N'Tirebolu', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (367, 1854, N'Yağlıdere', 30)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (368, 1369, N'Gümüşhane Merkez', 31)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (369, 1458, N'Kelkit', 31)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (370, 1822, N'Köse', 31)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (371, 1971, N'Kürtün', 31)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (372, 1660, N'Şiran', 31)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (373, 1684, N'Torul', 31)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (374, 1261, N'Çukurca', 32)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (375, 1377, N'Hakkari Merkez', 32)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (376, 1656, N'Şemdinli', 32)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (377, 1737, N'Yüksekova', 32)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (378, 1131, N'Altınözü', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (379, 1887, N'Belen', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (380, 1289, N'Dörtyol', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (381, 1792, N'Erzin', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (382, 1382, N'Hassa', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (383, 1383, N'Hatay Merkez', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (384, 1413, N'İskenderun', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (385, 1468, N'Kırıkhan', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (386, 1970, N'Kumlu', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (387, 1585, N'Reyhanlı', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (388, 1591, N'Samandağ', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (389, 1721, N'Yayladağı', 33)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (390, 1755, N'Aksu / Isparta', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (391, 1154, N'Atabey', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (392, 1297, N'Eğirdir', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (393, 1341, N'Gelendost', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (394, 1929, N'Gönen / Isparta', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (395, 1401, N'Isparta Merkez', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (396, 1456, N'Keçiborlu', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (397, 1615, N'Senirkent', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (398, 1648, N'Sütçüler', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (399, 1651, N'Şarkikaraağaç', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (400, 1699, N'Uluborlu', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (401, 1717, N'Yalvaç', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (402, 2001, N'Yenişarbademli', 34)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (403, 2064, N'Akdeniz', 35)
GO
print 'Processed 400 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (404, 1135, N'Anamur', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (405, 1766, N'Aydıncık / Mersin', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (406, 1779, N'Bozyazı', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (407, 1892, N'Çamlıyayla', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (408, 1311, N'Erdemli', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (409, 1366, N'Gülnar', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (410, 2065, N'Mezitli', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (411, 1536, N'Mut', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (412, 1621, N'Silifke', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (413, 1665, N'Tarsus', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (414, 2066, N'Toroslar', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (415, 2067, N'Yenişehir / Mersin', 35)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (416, 1103, N'Adalar', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (417, 2048, N'Arnavutköy', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (418, 2049, N'Ataşehir', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (419, 2003, N'Avcılar', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (420, 2004, N'Bağcılar', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (421, 2005, N'Bahçelievler', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (422, 1166, N'Bakırköy', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (423, 2050, N'Başakşehir', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (424, 1886, N'Bayrampaşa', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (425, 1183, N'Beşiktaş', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (426, 1185, N'Beykoz', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (427, 2051, N'Beylikdüzü', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (428, 1186, N'Beyoğlu', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (429, 1782, N'Büyükçekmece', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (430, 1237, N'Çatalca', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (431, 2052, N'Çekmeköy', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (432, 2016, N'Esenler', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (433, 2053, N'Esenyurt', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (434, 1325, N'Eyüp', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (435, 1327, N'Fatih', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (436, 1336, N'Gaziosmanpaşa', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (437, 2010, N'Güngören', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (438, 1421, N'Kadıköy', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (439, 1810, N'Kağıthane', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (440, 1449, N'Kartal', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (441, 1823, N'Küçükçekmece', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (442, 2012, N'Maltepe', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (443, 1835, N'Pendik', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (444, 2054, N'Sancaktepe', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (445, 1604, N'Sarıyer', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (446, 1622, N'Silivri', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (447, 2014, N'Sultanbeyli', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (448, 2055, N'Sultangazi', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (449, 1659, N'Şile', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (450, 1663, N'Şişli', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (451, 2015, N'Tuzla', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (452, 1852, N'Ümraniye', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (453, 1708, N'Üsküdar', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (454, 1739, N'Zeytinburnu', 36)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (455, 1128, N'Aliağa', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (456, 2006, N'Balçova', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (457, 1178, N'Bayındır', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (458, 2056, N'Bayraklı', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (459, 1181, N'Bergama', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (460, 1776, N'Beydağ', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (461, 1203, N'Bornova', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (462, 1780, N'Buca', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (463, 1251, N'Çeşme', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (464, 2007, N'Çiğli', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (465, 1280, N'Dikili', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (466, 1334, N'Foça', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (467, 2009, N'Gaziemir', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (468, 2018, N'Güzelbahçe', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (469, 2057, N'Karabağlar', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (470, 1432, N'Karaburun', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (471, 1448, N'Karşıyaka', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (472, 1461, N'Kemalpaşa', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (473, 1467, N'Kınık', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (474, 1477, N'Kiraz', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (475, 1819, N'Konak', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (476, 1826, N'Menderes', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (477, 1521, N'Menemen', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (478, 2013, N'Narlıdere', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (479, 1563, N'Ödemiş', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (480, 1611, N'Seferihisar', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (481, 1612, N'Selçuk', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (482, 1677, N'Tire', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (483, 1682, N'Torbalı', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (484, 1703, N'Urla', 37)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (485, 1756, N'Akyaka', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (486, 1149, N'Arpaçay', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (487, 1279, N'Digor', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (488, 1424, N'Kağızman', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (489, 1447, N'Kars Merkez', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (490, 1601, N'Sarıkamış', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (491, 1614, N'Selim', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (492, 1645, N'Susuz', 38)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (493, 1101, N'Abana', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (494, 1867, N'Ağlı', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (495, 1140, N'Araç', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (496, 1162, N'Azdavay', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (497, 1208, N'Bozkurt / Kastamonu', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (498, 1221, N'Cide', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (499, 1238, N'Çatalzeytin', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (500, 1264, N'Daday', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (501, 1277, N'Devrekani', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (502, 1915, N'Doğanyurt', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (503, 1940, N'Hanönü', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (504, 1805, N'İhsangazi', 39)
GO
print 'Processed 500 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (505, 1410, N'İnebolu', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (506, 1450, N'Kastamonu Merkez', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (507, 1499, N'Küre', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (508, 1836, N'Pınarbaşı / Kastamonu', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (509, 1984, N'Seydiler', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (510, 1845, N'Şenpazar', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (511, 1666, N'Taşköprü', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (512, 1685, N'Tosya', 39)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (513, 1752, N'Akkışla', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (514, 1218, N'Bünyan', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (515, 1275, N'Develi', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (516, 1330, N'Felahiye', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (517, 1936, N'Hacılar', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (518, 1409, N'İncesu', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (519, 1863, N'Kocasinan', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (520, 1864, N'Melikgazi', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (521, 1978, N'Özvatan', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (522, 1576, N'Pınarbaşı / Kayseri', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (523, 1603, N'Sarıoğlan', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (524, 1605, N'Sarız', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (525, 1846, N'Talas', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (526, 1680, N'Tomarza', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (527, 1715, N'Yahyalı', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (528, 1727, N'Yeşilhisar', 40)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (529, 1163, N'Babaeski', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (530, 1270, N'Demirköy', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (531, 1471, N'Kırklareli Merkez', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (532, 1480, N'Kofçaz', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (533, 1505, N'Lüleburgaz', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (534, 1572, N'Pehlivanköy', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (535, 1577, N'Pınarhisar', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (536, 1714, N'Vize', 41)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (537, 1869, N'Akçakent', 42)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (538, 1754, N'Akpınar', 42)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (539, 1890, N'Boztepe', 42)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (540, 1254, N'Çiçekdağı', 42)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (541, 1429, N'Kaman', 42)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (542, 1472, N'Kırşehir Merkez', 42)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (543, 1529, N'Mucur', 42)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (544, 2058, N'Başiskele', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (545, 2059, N'Çayırova', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (546, 2060, N'Darıca', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (547, 2030, N'Derince', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (548, 2061, N'Dilovası', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (549, 1338, N'Gebze', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (550, 1355, N'Gölcük', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (551, 2062, N'İzmit', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (552, 1430, N'Kandıra', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (553, 1440, N'Karamürsel', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (554, 2063, N'Kartepe', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (555, 1821, N'Körfez', 43)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (556, 1868, N'Ahırlı', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (557, 1753, N'Akören', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (558, 1122, N'Akşehir', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (559, 1760, N'Altınekin', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (560, 1188, N'Beyşehir', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (561, 1207, N'Bozkır', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (562, 1222, N'Cihanbeyli', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (563, 1902, N'Çeltik', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (564, 1262, N'Çumra', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (565, 1907, N'Derbent', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (566, 1789, N'Derebucak', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (567, 1285, N'Doğanhisar', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (568, 1920, N'Emirgazi', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (569, 1312, N'Ereğli / Konya', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (570, 1933, N'Güneysınır', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (571, 1375, N'Hadim', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (572, 1937, N'Halkapınar', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (573, 1804, N'Hüyük', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (574, 1400, N'Ilgın', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (575, 1422, N'Kadınhanı', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (576, 1441, N'Karapınar', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (577, 1814, N'Karatay', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (578, 1491, N'Kulu', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (579, 1827, N'Meram', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (580, 1598, N'Sarayönü', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (581, 1839, N'Selçuklu', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (582, 1617, N'Seydişehir', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (583, 1848, N'Taşkent', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (584, 1990, N'Tuzlukçu', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (585, 1994, N'Yalıhüyük', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (586, 1735, N'Yunak', 44)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (587, 1132, N'Altıntaş', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (588, 1764, N'Aslanapa', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (589, 1898, N'Çavdarhisar', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (590, 1288, N'Domaniç', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (591, 1790, N'Dumlupınar', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (592, 1304, N'Emet', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (593, 1339, N'Gediz', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (594, 1802, N'Hisarcık', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (595, 1500, N'Kütahya Merkez', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (596, 1979, N'Pazarlar', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (597, 1625, N'Simav', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (598, 1843, N'Şaphane', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (599, 1671, N'Tavşanlı', 45)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (600, 1114, N'Akçadağ', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (601, 1143, N'Arapgir', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (602, 1148, N'Arguvan', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (603, 1772, N'Battalgazi', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (604, 1265, N'Darende', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (605, 1286, N'Doğanşehir', 46)
GO
print 'Processed 600 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (606, 1914, N'Doğanyol', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (607, 1390, N'Hekimhan', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (608, 1953, N'Kale / Malatya', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (609, 1969, N'Kuluncak', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (610, 1509, N'Malatya Merkez', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (611, 1582, N'Pütürge', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (612, 1995, N'Yazıhan', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (613, 1729, N'Yeşilyurt / Malatya', 46)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (614, 1751, N'Ahmetli', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (615, 1118, N'Akhisar', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (616, 1127, N'Alaşehir', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (617, 1269, N'Demirci', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (618, 1793, N'Gölmarmara', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (619, 1362, N'Gördes', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (620, 1470, N'Kırkağaç', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (621, 1965, N'Köprübaşı / Manisa', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (622, 1489, N'Kula', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (623, 1513, N'Manisa Merkez', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (624, 1590, N'Salihli', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (625, 1600, N'Sarıgöl', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (626, 1606, N'Saruhanlı', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (627, 1613, N'Selendi', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (628, 1634, N'Soma', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (629, 1689, N'Turgutlu', 47)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (630, 1107, N'Afşin', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (631, 1136, N'Andırın', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (632, 1785, N'Çağlıyancerit', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (633, 1919, N'Ekinözü', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (634, 1299, N'Elbistan', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (635, 1353, N'Göksun', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (636, 1515, N'Kahramanmaraş Merkez', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (637, 1975, N'Nurhak', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (638, 1570, N'Pazarcık', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (639, 1694, N'Türkoğlu', 48)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (640, 1787, N'Dargeçit', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (641, 1273, N'Derik', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (642, 1474, N'Kızıltepe', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (643, 1516, N'Mardin Merkez', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (644, 1519, N'Mazıdağı', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (645, 1526, N'Midyat', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (646, 1547, N'Nusaybin', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (647, 1564, N'Ömerli', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (648, 1609, N'Savur', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (649, 2002, N'Yeşilli', 49)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (650, 1197, N'Bodrum', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (651, 1742, N'Dalaman', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (652, 1266, N'Datça', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (653, 1331, N'Fethiye', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (654, 1958, N'Kavaklıdere', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (655, 1488, N'Köyceğiz', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (656, 1517, N'Marmaris', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (657, 1528, N'Milas', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (658, 1532, N'Muğla Merkez', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (659, 1831, N'Ortaca', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (660, 1695, N'Ula', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (661, 1719, N'Yatağan', 50)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (662, 1213, N'Bulanık', 51)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (663, 1801, N'Hasköy', 51)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (664, 1964, N'Korkut', 51)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (665, 1510, N'Malazgirt', 51)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (666, 1534, N'Muş Merkez', 51)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (667, 1711, N'Varto', 51)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (668, 1749, N'Acıgöl', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (669, 1155, N'Avanos', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (670, 1274, N'Derinkuyu', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (671, 1367, N'Gülşehir', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (672, 1374, N'Hacıbektaş', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (673, 1485, N'Kozaklı', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (674, 1543, N'Nevşehir Merkez', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (675, 1707, N'Ürgüp', 52)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (676, 1876, N'Altunhisar', 53)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (677, 1201, N'Bor', 53)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (678, 1225, N'Çamardı', 53)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (679, 1904, N'Çiftlik', 53)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (680, 1544, N'Niğde Merkez', 53)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (681, 1700, N'Ulukışla', 53)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (682, 1119, N'Akkuş', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (683, 1158, N'Aybastı', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (684, 1891, N'Çamaş', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (685, 1897, N'Çatalpınar', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (686, 1900, N'Çaybaşı', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (687, 1328, N'Fatsa', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (688, 1358, N'Gölköy', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (689, 1795, N'Gülyalı', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (690, 1797, N'Gürgentepe', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (691, 1947, N'İkizce', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (692, 1950, N'Kabadüz', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (693, 1951, N'Kabataş', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (694, 1482, N'Korgan', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (695, 1493, N'Kumru', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (696, 1525, N'Mesudiye', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (697, 1552, N'Ordu Merkez', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (698, 1573, N'Perşembe', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (699, 1696, N'Ulubey / Ordu', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (700, 1706, N'Ünye', 54)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (701, 1146, N'Ardeşen', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (702, 1228, N'Çamlıhemşin', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (703, 1241, N'Çayeli', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (704, 1908, N'Derepazarı', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (705, 1332, N'Fındıklı', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (706, 1796, N'Güneysu', 55)
GO
print 'Processed 700 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (707, 1943, N'Hemşin', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (708, 1405, N'İkizdere', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (709, 1949, N'İyidere', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (710, 1428, N'Kalkandere', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (711, 1569, N'Pazar / Rize', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (712, 1586, N'Rize Merkez', 55)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (713, 2068, N'Adapazarı', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (714, 1123, N'Akyazı', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (715, 2069, N'Arifiye', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (716, 2070, N'Erenler', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (717, 1925, N'Ferizli', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (718, 1351, N'Geyve', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (719, 1391, N'Hendek', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (720, 1955, N'Karapürçek', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (721, 1442, N'Karasu', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (722, 1453, N'Kaynarca', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (723, 1818, N'Kocaali', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (724, 1833, N'Pamukova', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (725, 1595, N'Sapanca', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (726, 2071, N'Serdivan', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (727, 1986, N'Söğütlü', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (728, 1847, N'Taraklı', 56)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (729, 1125, N'Alaçam', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (730, 1763, N'Asarcık', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (731, 2072, N'Atakum', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (732, 1879, N'Ayvacık / Samsun', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (733, 1164, N'Bafra', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (734, 2073, N'Canik', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (735, 1234, N'Çarşamba', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (736, 1386, N'Havza', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (737, 2074, N'İlkadım', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (738, 1452, N'Kavak', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (739, 1501, N'Ladik', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (740, 1830, N'Ondokuzmayıs', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (741, 1838, N'Salıpazarı', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (742, 1849, N'Tekkeköy', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (743, 1676, N'Terme', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (744, 1712, N'Vezirköprü', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (745, 1993, N'Yakakent', 57)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (746, 1878, N'Aydınlar', 58)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (747, 1179, N'Baykan', 58)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (748, 1317, N'Eruh', 58)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (749, 1495, N'Kurtalan', 58)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (750, 1575, N'Pervari', 58)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (751, 1620, N'Siirt Merkez', 58)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (752, 1662, N'Şirvan', 58)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (753, 1156, N'Ayancık', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (754, 1204, N'Boyabat', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (755, 1910, N'Dikmen', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (756, 1290, N'Durağan', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (757, 1314, N'Erfelek', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (758, 1349, N'Gerze', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (759, 1981, N'Saraydüzü', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (760, 1627, N'Sinop Merkez', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (761, 1693, N'Türkeli', 59)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (762, 1870, N'Akıncılar', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (763, 1875, N'Altınyayla / Sivas', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (764, 1282, N'Divriği', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (765, 1913, N'Doğanşar', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (766, 1342, N'Gemerek', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (767, 1927, N'Gölova', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (768, 1373, N'Gürün', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (769, 1376, N'Hafik', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (770, 1407, N'İmranlı', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (771, 1431, N'Kangal', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (772, 1484, N'Koyulhisar', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (773, 1628, N'Sivas Merkez', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (774, 1646, N'Suşehri', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (775, 1650, N'Şarkışla', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (776, 1991, N'Ulaş', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (777, 1731, N'Yıldızeli', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (778, 1738, N'Zara', 60)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (779, 1250, N'Çerkezköy', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (780, 1258, N'Çorlu', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (781, 1388, N'Hayrabolu', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (782, 1511, N'Malkara', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (783, 1825, N'Marmaraereğlisi', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (784, 1538, N'Muratlı', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (785, 1596, N'Saray / Tekirdağ', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (786, 1652, N'Şarköy', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (787, 1673, N'Tekirdağ Merkez', 61)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (788, 1129, N'Almus', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (789, 1151, N'Artova', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (790, 1883, N'Başçiftlik', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (791, 1308, N'Erbaa', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (792, 1545, N'Niksar', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (793, 1834, N'Pazar / Tokat', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (794, 1584, N'Reşadiye', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (795, 1987, N'Sulusaray', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (796, 1679, N'Tokat Merkez', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (797, 1690, N'Turhal', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (798, 1858, N'Yeşilyurt / Tokat', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (799, 1740, N'Zile', 62)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (800, 1113, N'Akçaabat', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (801, 1141, N'Araklı', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (802, 1150, N'Arsin', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (803, 1775, N'Beşikdüzü', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (804, 1896, N'Çarşıbaşı', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (805, 1244, N'Çaykara', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (806, 1909, N'Dernekpazarı', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (807, 1917, N'Düzköy', 63)
GO
print 'Processed 800 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (808, 1942, N'Hayrat', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (809, 1966, N'Köprübaşı / Trabzon', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (810, 1507, N'Maçka', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (811, 1548, N'Of', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (812, 1647, N'Sürmene', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (813, 1842, N'Şalpazarı', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (814, 1681, N'Tonya', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (815, 1686, N'Trabzon Merkez', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (816, 1709, N'Vakfıkebir', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (817, 1732, N'Yomra', 63)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (818, 1247, N'Çemişgezek', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (819, 1397, N'Hozat', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (820, 1518, N'Mazgirt', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (821, 1541, N'Nazımiye', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (822, 1562, N'Ovacık / Tunceli', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (823, 1574, N'Pertek', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (824, 1581, N'Pülümür', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (825, 1688, N'Tunceli Merkez', 64)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (826, 1115, N'Akçakale', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (827, 1194, N'Birecik', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (828, 1209, N'Bozova', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (829, 1220, N'Ceylanpınar', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (830, 1378, N'Halfeti', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (831, 1800, N'Harran', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (832, 1393, N'Hilvan', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (833, 1630, N'Siverek', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (834, 1643, N'Suruç', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (835, 1702, N'Şanlıurfa Merkez', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (836, 1713, N'Viranşehir', 65)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (837, 1170, N'Banaz', 66)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (838, 1323, N'Eşme', 66)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (839, 1436, N'Karahallı', 66)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (840, 1629, N'Sivaslı', 66)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (841, 1697, N'Ulubey / Uşak', 66)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (842, 1704, N'Uşak Merkez', 66)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (843, 1770, N'Bahçesaray', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (844, 1175, N'Başkale', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (845, 1786, N'Çaldıran', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (846, 1236, N'Çatak', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (847, 1918, N'Edremit / Van', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (848, 1309, N'Erciş', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (849, 1350, N'Gevaş', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (850, 1372, N'Gürpınar', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (851, 1533, N'Muradiye', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (852, 1565, N'Özalp', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (853, 1980, N'Saray / Van', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (854, 1710, N'Van Merkez', 67)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (855, 1117, N'Akdağmadeni', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (856, 1877, N'Aydıncık / Yozgat', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (857, 1198, N'Boğazlıyan', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (858, 1895, N'Çandır', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (859, 1242, N'Çayıralan', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (860, 1245, N'Çekerek', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (861, 1952, N'Kadışehri', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (862, 1982, N'Saraykent', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (863, 1602, N'Sarıkaya', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (864, 1635, N'Sorgun', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (865, 1655, N'Şefaatli', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (866, 1998, N'Yenifakılı', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (867, 1726, N'Yerköy', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (868, 1733, N'Yozgat Merkez', 68)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (869, 1758, N'Alaplı', 69)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (870, 1240, N'Çaycuma', 69)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (871, 1276, N'Devrek', 69)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (872, 1313, N'Ereğli / Zonguldak', 69)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (873, 1926, N'Gökçebey', 69)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (874, 1741, N'Zonguldak Merkez', 69)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (875, 1860, N'Ağaçören', 70)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (876, 1120, N'Aksaray Merkez', 70)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (877, 1921, N'Eskil', 70)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (878, 1932, N'Gülağaç', 70)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (879, 1861, N'Güzelyurt', 70)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (880, 1557, N'Ortaköy', 70)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (881, 1866, N'Sarıyahşi', 70)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (882, 1767, N'Aydıntepe', 71)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (883, 1176, N'Bayburt Merkez', 71)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (884, 1788, N'Demirözü', 71)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (885, 1768, N'Ayrancı', 72)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (886, 1884, N'Başyayla', 72)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (887, 1316, N'Ermenek', 72)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (888, 1439, N'Karaman Merkez', 72)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (889, 1862, N'Kazımkarabekir', 72)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (890, 1983, N'Sarıveliler', 72)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (891, 1880, N'Bahşili', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (892, 1882, N'Balışeyh', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (893, 1901, N'Çelebi', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (894, 1268, N'Delice', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (895, 1954, N'Karakeçili', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (896, 1463, N'Keskin', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (897, 1469, N'Kırıkkale Merkez', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (898, 1638, N'Sulakyurt', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (899, 1992, N'Yahşihan', 73)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (900, 1174, N'Batman Merkez', 74)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (901, 1184, N'Beşiri', 74)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (902, 1345, N'Gercüş', 74)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (903, 1941, N'Hasankeyf', 74)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (904, 1487, N'Kozluk', 74)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (905, 1607, N'Sason', 74)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (906, 1189, N'Beytüşşebap', 75)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (907, 1223, N'Cizre', 75)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (908, 1931, N'Güçlükonak', 75)
GO
print 'Processed 900 total records'
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (909, 1403, N'İdil', 75)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (910, 1623, N'Silopi', 75)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (911, 1661, N'Şırnak Merkez', 75)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (912, 1698, N'Uludere', 75)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (913, 1761, N'Amasra', 76)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (914, 1172, N'Bartın Merkez', 76)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (915, 1496, N'Kurucaşile', 76)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (916, 1701, N'Ulus', 76)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (917, 1144, N'Ardahan Merkez', 77)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (918, 1252, N'Çıldır', 77)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (919, 2008, N'Damal', 77)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (920, 1356, N'Göle', 77)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (921, 1380, N'Hanak', 77)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (922, 1579, N'Posof', 77)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (923, 1142, N'Aralık', 78)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (924, 1398, N'Iğdır Merkez', 78)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (925, 2011, N'Karakoyunlu', 78)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (926, 1692, N'Tuzluca', 78)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (927, 2019, N'Altınova', 79)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (928, 2020, N'Armutlu', 79)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (929, 2021, N'Çınarcık', 79)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (930, 2022, N'Çiftlikköy', 79)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (931, 2026, N'Termal', 79)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (932, 1716, N'Yalova Merkez', 79)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (933, 1296, N'Eflani', 80)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (934, 1321, N'Eskipazar', 80)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (935, 1433, N'Karabük Merkez', 80)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (936, 1561, N'Ovacık / Karabük', 80)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (937, 1587, N'Safranbolu', 80)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (938, 1856, N'Yenice / Karabük', 80)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (939, 2023, N'Elbeyli', 81)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (940, 1476, N'Kilis Merkez', 81)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (941, 2024, N'Musabeyli', 81)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (942, 2025, N'Polateli', 81)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (943, 1165, N'Bahçe', 82)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (944, 1743, N'Düziçi', 82)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (945, 2027, N'Hasanbeyli', 82)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (946, 1423, N'Kadirli', 82)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (947, 1560, N'Osmaniye Merkez', 82)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (948, 2028, N'Sumbas', 82)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (949, 2029, N'Toprakkale', 82)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (950, 1116, N'Akçakoca', 83)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (951, 1784, N'Cumayeri', 83)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (952, 1905, N'Çilimli', 83)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (953, 1292, N'Düzce Merkez', 83)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (954, 1794, N'Gölyaka', 83)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (955, 2017, N'Gümüşova', 83)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (956, 2031, N'Kaynaşlı', 83)
INSERT [enterprise].[Town] ([Id], [TownCode], [Name], [CityId]) VALUES (957, 1730, N'Yığılca', 83)
SET IDENTITY_INSERT [enterprise].[Town] OFF
/****** Object:  ForeignKey [FK_Town_City]    Script Date: 04/20/2013 13:51:32 ******/
ALTER TABLE [enterprise].[Town]  WITH CHECK ADD  CONSTRAINT [FK_Town_City] FOREIGN KEY([CityId])
REFERENCES [enterprise].[City] ([Id])
GO
ALTER TABLE [enterprise].[Town] CHECK CONSTRAINT [FK_Town_City]
GO
